﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;


namespace Intex.Db.Service
{
    public class ImportData
    {
        public DataTable ImportForExcel(string fileName)
        {
            OleDbConnection cnn = new OleDbConnection(string.Format(connStr, fileName));
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = cnn;
            cnn.Open();
            DataTable dt = new DataTable();

            return dt;
        }

        private const string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;'";
    }
}
